package com.qdu.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.qdu.entity.Grade;

public interface GradeMapper {

	Grade getGradeById(String gradeId);

	Grade getGradeBySrollnoAndCpid(@Param("srollno") String srollno, @Param("cpid") int cpid);

	List<Grade> getGradeByStudentId(String srollno);

	List<Grade> getAllGrade();

	List<Grade> getGradeByCpid(int cpid);

	boolean addGrade(@Param("grade") Grade grade, @Param("srollno") String srollno, @Param("cpid") int cpid,
			@Param("pass") int pass);

	boolean modifyGrade(@Param("grade") Grade grade, @Param("srollno") String srollno, @Param("cpid") int cpid,
			@Param("pass") int pass);

	boolean deleteGradeById(String gradeId);

}
